CREATE TABLE IF NOT EXISTS `region_auvergne` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ordre_ville` int(11) DEFAULT NULL,
  `ordre_departement` int(11) NOT NULL DEFAULT '500',
  `region` varchar(50) DEFAULT NULL,
  `departement` varchar(50) DEFAULT NULL,
  `code_postale` varchar(5) NOT NULL,
  `ville` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3280 ;

--
-- Contenu de la table `region_auvergne`
--

INSERT INTO `region_auvergne` (`id`, `ordre_ville`, `ordre_departement`, `region`, `departement`, `code_postale`, `ville`) VALUES
('', '', '', 'Auvergne', 'Allier (03)','03200', 'ABREST'),
('', '', '', 'Auvergne', 'Allier (03)','03210', 'AGONGES'),
('', '', '', 'Auvergne', 'Allier (03)','03360', 'AINAY LE CHATEAU'),
('', '', '', 'Auvergne', 'Allier (03)','03120', 'ANDELAROCHE'),
('', '', '', 'Auvergne', 'Allier (03)','03380', 'ARCHIGNAT'),
('', '', '', 'Auvergne', 'Allier (03)','03640', 'ARFEUILLES'),
('', '', '', 'Auvergne', 'Allier (03)','03420', 'ARPHEUILLES SAINT PRIEST'),
('', '', '', 'Auvergne', 'Allier (03)','03250', 'ARRONNES'),
('', '', '', 'Auvergne', 'Allier (03)','03460', 'AUBIGNY'),
('', '', '', 'Auvergne', 'Allier (03)','03190', 'AUDES'),
('', '', '', 'Auvergne', 'Allier (03)','03460', 'AUROUER'),
('', '', '', 'Auvergne', 'Allier (03)','03210', 'AUTRY ISSARDS'),
('', '', '', 'Auvergne', 'Allier (03)','03000', 'AVERMES'),
('', '', '', 'Auvergne', 'Allier (03)','03130', 'AVRILLY'),
('', '', '', 'Auvergne', 'Allier (03)','03460', 'BAGNEUX'),
('', '', '', 'Auvergne', 'Allier (03)','03140', 'BARBERIER'),
('', '', '', 'Auvergne', 'Allier (03)','03120', 'BARRAIS BUSSOLLES'),
('', '', '', 'Auvergne', 'Allier (03)','03500', 'BAYET'),
('', '', '', 'Auvergne', 'Allier (03)','03230', 'BEAULON'),
('', '', '', 'Auvergne', 'Allier (03)','03390', 'BEAUNE D''ALLIER'),
('', '', '', 'Auvergne', 'Allier (03)','03800', 'BEGUES'),
('', '', '', 'Auvergne', 'Allier (03)','03330', 'BELLENAVES'),
('', '', '', 'Auvergne', 'Allier (03)','03700', 'BELLERIVE SUR ALLIER'),
('', '', '', 'Auvergne', 'Allier (03)','03130', 'BERT'),
('', '', '', 'Auvergne', 'Allier (03)','03340', 'BESSAY SUR ALLIER'),
('', '', '', 'Auvergne', 'Allier (03)','03210', 'BESSON'),
('', '', '', 'Auvergne', 'Allier (03)','03170', 'BEZENET'),
('', '', '', 'Auvergne', 'Allier (03)','03120', 'BILLEZOIS'),
('', '', '', 'Auvergne', 'Allier (03)','03260', 'BILLY'),
('', '', '', 'Auvergne', 'Allier (03)','03800', 'BIOZAT'),
('', '', '', 'Auvergne', 'Allier (03)','03170', 'BIZENEUILLE'),
('', '', '', 'Auvergne', 'Allier (03)','03390', 'BLOMARD'),
('', '', '', 'Auvergne', 'Allier (03)','03300', 'BOST'),
('', '', '', 'Auvergne', 'Allier (03)','03150', 'BOUCE'),
('', '', '', 'Auvergne', 'Allier (03)','03130', 'BOUCHAUD (LE)'),
('', '', '', 'Auvergne', 'Allier (03)','03160', 'BOURBON L''ARCHAMBAULT'),
('', '', '', 'Auvergne', 'Allier (03)','03360', 'BRAIZE'),
('', '', '', 'Auvergne', 'Allier (03)','03500', 'BRANSAT'),
('', '', '', 'Auvergne', 'Allier (03)','03210', 'BRESNAY'),
('', '', '', 'Auvergne', 'Allier (03)','03000', 'BRESSOLLES'),
('', '', '', 'Auvergne', 'Allier (03)','03350', 'BRETHON (LE)'),
('', '', '', 'Auvergne', 'Allier (03)','03120', 'BREUIL (LE)'),
('', '', '', 'Auvergne', 'Allier (03)','03110', 'BROUT VERNET'),
('', '', '', 'Auvergne', 'Allier (03)','03700', 'BRUGHEAS'),
('', '', '', 'Auvergne', 'Allier (03)','03270', 'BUSSET'),
('', '', '', 'Auvergne', 'Allier (03)','03440', 'BUXIERES LES MINES'),
('', '', '', 'Auvergne', 'Allier (03)','03600', 'CELLE (LA)'),
('', '', '', 'Auvergne', 'Allier (03)','03350', 'CERILLY'),
('', '', '', 'Auvergne', 'Allier (03)','03500', 'CESSET'),
('', '', '', 'Auvergne', 'Allier (03)','03250', 'CHABANNE (LA)'),
('', '', '', 'Auvergne', 'Allier (03)','03370', 'CHAMBERAT'),
('', '', '', 'Auvergne', 'Allier (03)','03170', 'CHAMBLET'),
('', '', '', 'Auvergne', 'Allier (03)','03140', 'CHANTELLE'),
('', '', '', 'Auvergne', 'Allier (03)','03340', 'CHAPEAU'),
('', '', '', 'Auvergne', 'Allier (03)','03380', 'CHAPELAUDE (LA)'),
('', '', '', 'Auvergne', 'Allier (03)','03300', 'CHAPELLE (LA)'),
('', '', '', 'Auvergne', 'Allier (03)','03230', 'CHAPELLE AUX CHASSES (LA)'),
('', '', '', 'Auvergne', 'Allier (03)','03390', 'CHAPPES'),
('', '', '', 'Auvergne', 'Allier (03)','03140', 'CHAREIL CINTRAT'),
('', '', '', 'Auvergne', 'Allier (03)','03110', 'CHARMEIL'),
('', '', '', 'Auvergne', 'Allier (03)','03800', 'CHARMES'),
('', '', '', 'Auvergne', 'Allier (03)','03140', 'CHARROUX'),
('', '', '', 'Auvergne', 'Allier (03)','03510', 'CHASSENARD'),
('', '', '', 'Auvergne', 'Allier (03)','03320', 'CHATEAU SUR ALLIER'),
('', '', '', 'Auvergne', 'Allier (03)','03500', 'CHATEL DE NEUVRE'),
('', '', '', 'Auvergne', 'Allier (03)','03250', 'CHATEL MONTAGNE'),
('', '', '', 'Auvergne', 'Allier (03)','03220', 'CHATELPERRON'),
('', '', '', 'Auvergne', 'Allier (03)','03640', 'CHATELUS'),
('', '', '', 'Auvergne', 'Allier (03)','03210', 'CHATILLON'),
('', '', '', 'Auvergne', 'Allier (03)','03440', 'CHAVENON'),
('', '', '', 'Auvergne', 'Allier (03)','03220', 'CHAVROCHES'),
('', '', '', 'Auvergne', 'Allier (03)','03370', 'CHAZEMAIS'),
('', '', '', 'Auvergne', 'Allier (03)','03210', 'CHEMILLY'),
('', '', '', 'Auvergne', 'Allier (03)','03230', 'CHEVAGNES'),
('', '', '', 'Auvergne', 'Allier (03)','03140', 'CHEZELLE'),
('', '', '', 'Auvergne', 'Allier (03)','03230', 'CHEZY'),
('', '', '', 'Auvergne', 'Allier (03)','03330', 'CHIRAT L''EGLISE'),
('', '', '', 'Auvergne', 'Allier (03)','03450', 'CHOUVIGNY'),
('', '', '', 'Auvergne', 'Allier (03)','03220', 'CINDRE'),
('', '', '', 'Auvergne', 'Allier (03)','03110', 'COGNAT LYONNE'),
('', '', '', 'Auvergne', 'Allier (03)','03600', 'COLOMBIER'),
('', '', '', 'Auvergne', 'Allier (03)','03600', 'COMMENTRY'),
('', '', '', 'Auvergne', 'Allier (03)','03500', 'CONTIGNY'),
('', '', '', 'Auvergne', 'Allier (03)','03430', 'COSNE D''ALLIER'),
('', '', '', 'Auvergne', 'Allier (03)','03000', 'COULANDON'),
('', '', '', 'Auvergne', 'Allier (03)','03470', 'COULANGES'),
('', '', '', 'Auvergne', 'Allier (03)','03320', 'COULEUVRE'),
('', '', '', 'Auvergne', 'Allier (03)','03370', 'COURCAIS'),
('', '', '', 'Auvergne', 'Allier (03)','03330', 'COUTANSOUZE'),
('', '', '', 'Auvergne', 'Allier (03)','03160', 'COUZON'),
('', '', '', 'Auvergne', 'Allier (03)','03150', 'CRECHY'),
('', '', '', 'Auvergne', 'Allier (03)','03240', 'CRESSANGES'),
('', '', '', 'Auvergne', 'Allier (03)','03300', 'CREUZIER LE NEUF'),
('', '', '', 'Auvergne', 'Allier (03)','03300', 'CREUZIER LE VIEUX'),
('', '', '', 'Auvergne', 'Allier (03)','03300', 'CUSSET'),
('', '', '', 'Auvergne', 'Allier (03)','03140', 'DENEUILLE LES CHANTELLE'),
('', '', '', 'Auvergne', 'Allier (03)','03170', 'DENEUILLE LES MINES'),
('', '', '', 'Auvergne', 'Allier (03)','03630', 'DESERTINES'),
('', '', '', 'Auvergne', 'Allier (03)','03240', 'DEUX CHAISES'),
('', '', '', 'Auvergne', 'Allier (03)','03290', 'DIOU'),
('', '', '', 'Auvergne', 'Allier (03)','03410', 'DOMERAT'),
('', '', '', 'Auvergne', 'Allier (03)','03290', 'DOMPIERRE SUR BESBRE'),
('', '', '', 'Auvergne', 'Allier (03)','03130', 'DONJON (LE)'),
('', '', '', 'Auvergne', 'Allier (03)','03170', 'DOYET'),
('', '', '', 'Auvergne', 'Allier (03)','03120', 'DROITURIER'),
('', '', '', 'Auvergne', 'Allier (03)','03310', 'DURDAT LAREQUILLE'),
('', '', '', 'Auvergne', 'Allier (03)','03450', 'EBREUIL'),
('', '', '', 'Auvergne', 'Allier (03)','03330', 'ECHASSIERES'),
('', '', '', 'Auvergne', 'Allier (03)','03110', 'ESCUROLLES'),
('', '', '', 'Auvergne', 'Allier (03)','03110', 'ESPINASSE VOZELLE'),
('', '', '', 'Auvergne', 'Allier (03)','03190', 'ESTIVAREILLES'),
('', '', '', 'Auvergne', 'Allier (03)','03140', 'ETROUSSAT'),
('', '', '', 'Auvergne', 'Allier (03)','03250', 'FERRIERES SUR SICHON'),
('', '', '', 'Auvergne', 'Allier (03)','03340', 'FERTE HAUTERIVE (LA)'),
('', '', '', 'Auvergne', 'Allier (03)','03140', 'FLEURIEL'),
('', '', '', 'Auvergne', 'Allier (03)','03140', 'FOURILLES'),
('', '', '', 'Auvergne', 'Allier (03)','03160', 'FRANCHESSE'),
('', '', '', 'Auvergne', 'Allier (03)','03800', 'GANNAT'),
('', '', '', 'Auvergne', 'Allier (03)','03230', 'GANNAY SUR LOIRE'),
('', '', '', 'Auvergne', 'Allier (03)','03230', 'GARNAT SUR ENGIEVRE'),
('', '', '', 'Auvergne', 'Allier (03)','03400', 'GENNETINES'),
('', '', '', 'Auvergne', 'Allier (03)','03210', 'GIPCY'),
('', '', '', 'Auvergne', 'Allier (03)','03190', 'GIVARLAIS'),
('', '', '', 'Auvergne', 'Allier (03)','03340', 'GOUISE'),
('', '', '', 'Auvergne', 'Allier (03)','03250', 'GUILLERMIE (LA)'),
('', '', '', 'Auvergne', 'Allier (03)','03270', 'HAUTERIVE'),
('', '', '', 'Auvergne', 'Allier (03)','03190', 'HERISSON'),
('', '', '', 'Auvergne', 'Allier (03)','03380', 'HURIEL'),
('', '', '', 'Auvergne', 'Allier (03)','03600', 'HYDS'),
('', '', '', 'Auvergne', 'Allier (03)','03360', 'ISLE ET BARDAIS'),
('', '', '', 'Auvergne', 'Allier (03)','03120', 'ISSERPENT'),
('', '', '', 'Auvergne', 'Allier (03)','03220', 'JALIGNY SUR BESBRE'),
('', '', '', 'Auvergne', 'Allier (03)','03800', 'JENZAT'),
('', '', '', 'Auvergne', 'Allier (03)','03500', 'LAFELINE'),
('', '', '', 'Auvergne', 'Allier (03)','03450', 'LALIZOLLE'),
('', '', '', 'Auvergne', 'Allier (03)','03380', 'LAMAIDS'),
('', '', '', 'Auvergne', 'Allier (03)','03150', 'LANGY'),
('', '', '', 'Auvergne', 'Allier (03)','03120', 'LAPALISSE'),
('', '', '', 'Auvergne', 'Allier (03)','03250', 'LAPRUGNE'),
('', '', '', 'Auvergne', 'Allier (03)','03310', 'LAVAULT SAINTE ANNE'),
('', '', '', 'Auvergne', 'Allier (03)','03250', 'LAVOINE'),
('', '', '', 'Auvergne', 'Allier (03)','03130', 'LENAX'),
('', '', '', 'Auvergne', 'Allier (03)','03360', 'LETELON'),
('', '', '', 'Auvergne', 'Allier (03)','03130', 'LIERNOLLES'),
('', '', '', 'Auvergne', 'Allier (03)','03410', 'LIGNEROLLES'),
('', '', '', 'Auvergne', 'Allier (03)','03320', 'LIMOISE'),
('', '', '', 'Auvergne', 'Allier (03)','03130', 'LODDES'),
('', '', '', 'Auvergne', 'Allier (03)','03500', 'LORIGES'),
('', '', '', 'Auvergne', 'Allier (03)','03500', 'LOUCHY MONTFAND'),
('', '', '', 'Auvergne', 'Allier (03)','03350', 'LOUROUX BOURBONNAIS'),
('', '', '', 'Auvergne', 'Allier (03)','03600', 'LOUROUX DE BEAUNE'),
('', '', '', 'Auvergne', 'Allier (03)','03330', 'LOUROUX DE BOUBLE'),
('', '', '', 'Auvergne', 'Allier (03)','03190', 'LOUROUX HODEMENT'),
('', '', '', 'Auvergne', 'Allier (03)','03130', 'LUNEAU'),
('', '', '', 'Auvergne', 'Allier (03)','03320', 'LURCY LEVIS'),
('', '', '', 'Auvergne', 'Allier (03)','03230', 'LUSIGNY'),
('', '', '', 'Auvergne', 'Allier (03)','03260', 'MAGNET'),
('', '', '', 'Auvergne', 'Allier (03)','03190', 'MAILLET'),
('', '', '', 'Auvergne', 'Allier (03)','03600', 'MALICORNE'),
('', '', '', 'Auvergne', 'Allier (03)','03260', 'MARCENAT'),
('', '', '', 'Auvergne', 'Allier (03)','03420', 'MARCILLAT EN COMBRAILLE'),
('', '', '', 'Auvergne', 'Allier (03)','03210', 'MARIGNY'),
('', '', '', 'Auvergne', 'Allier (03)','03270', 'MARIOL'),
('', '', '', 'Auvergne', 'Allier (03)','03250', 'MAYET DE MONTAGNE (LE)'),
('', '', '', 'Auvergne', 'Allier (03)','03800', 'MAYET D''ECOLE (LE)'),
('', '', '', 'Auvergne', 'Allier (03)','03800', 'MAZERIER'),
('', '', '', 'Auvergne', 'Allier (03)','03420', 'MAZIRAT'),
('', '', '', 'Auvergne', 'Allier (03)','03360', 'MEAULNE'),
('', '', '', 'Auvergne', 'Allier (03)','03500', 'MEILLARD'),
('', '', '', 'Auvergne', 'Allier (03)','03210', 'MEILLERS'),
('', '', '', 'Auvergne', 'Allier (03)','03340', 'MERCY'),
('', '', '', 'Auvergne', 'Allier (03)','03370', 'MESPLES'),
('', '', '', 'Auvergne', 'Allier (03)','03510', 'MOLINET'),
('', '', '', 'Auvergne', 'Allier (03)','03300', 'MOLLES'),
('', '', '', 'Auvergne', 'Allier (03)','03140', 'MONESTIER'),
('', '', '', 'Auvergne', 'Allier (03)','03500', 'MONETAY SUR ALLIER'),
('', '', '', 'Auvergne', 'Allier (03)','03470', 'MONETAY SUR LOIRE'),
('', '', '', 'Auvergne', 'Allier (03)','03150', 'MONTAIGU LE BLIN'),
('', '', '', 'Auvergne', 'Allier (03)','03130', 'MONTAIGUET EN FOREZ'),
('', '', '', 'Auvergne', 'Allier (03)','03340', 'MONTBEUGNY'),
('', '', '', 'Auvergne', 'Allier (03)','03130', 'MONTCOMBROUX LES MINES'),
('', '', '', 'Auvergne', 'Allier (03)','03800', 'MONTEIGNET SUR L''ANDELOT'),
('', '', '', 'Auvergne', 'Allier (03)','03240', 'MONTET (LE)'),
('', '', '', 'Auvergne', 'Allier (03)','03000', 'MONTILLY'),
('', '', '', 'Auvergne', 'Allier (03)','03100', 'MONTLUCON'),
('', '', '', 'Auvergne', 'Allier (03)','03390', 'MONTMARAULT'),
('', '', '', 'Auvergne', 'Allier (03)','03150', 'MONTOLDRE'),
('', '', '', 'Auvergne', 'Allier (03)','03500', 'MONTORD'),
('', '', '', 'Auvergne', 'Allier (03)','03170', 'MONTVICQ'),
('', '', '', 'Auvergne', 'Allier (03)','03000', 'MOULINS'),
('', '', '', 'Auvergne', 'Allier (03)','03390', 'MURAT'),
('', '', '', 'Auvergne', 'Allier (03)','03450', 'NADES'),
('', '', '', 'Auvergne', 'Allier (03)','03190', 'NASSIGNY'),
('', '', '', 'Auvergne', 'Allier (03)','03330', 'NAVES'),
('', '', '', 'Auvergne', 'Allier (03)','03310', 'NERIS LES BAINS'),
('', '', '', 'Auvergne', 'Allier (03)','03130', 'NEUILLY EN DONJON'),
('', '', '', 'Auvergne', 'Allier (03)','03340', 'NEUILLY LE REAL'),
('', '', '', 'Auvergne', 'Allier (03)','03320', 'NEURE'),
('', '', '', 'Auvergne', 'Allier (03)','03000', 'NEUVY'),
('', '', '', 'Auvergne', 'Allier (03)','03250', 'NIZEROLLES'),
('', '', '', 'Auvergne', 'Allier (03)','03210', 'NOYANT D''ALLIER'),
('', '', '', 'Auvergne', 'Allier (03)','03230', 'PARAY LE FRESIL'),
('', '', '', 'Auvergne', 'Allier (03)','03500', 'PARAY SOUS BRIAILLES'),
('', '', '', 'Auvergne', 'Allier (03)','03120', 'PERIGNY'),
('', '', '', 'Auvergne', 'Allier (03)','03420', 'PETITE MARCHE (LA)'),
('', '', '', 'Auvergne', 'Allier (03)','03470', 'PIERREFITTE SUR LOIRE'),
('', '', '', 'Auvergne', 'Allier (03)','03130', 'PIN (LE)'),
('', '', '', 'Auvergne', 'Allier (03)','03800', 'POEZAT'),
('', '', '', 'Auvergne', 'Allier (03)','03320', 'POUZY MESANGY'),
('', '', '', 'Auvergne', 'Allier (03)','03410', 'PREMILHAT'),
('', '', '', 'Auvergne', 'Allier (03)','03380', 'QUINSSAINES'),
('', '', '', 'Auvergne', 'Allier (03)','03190', 'REUGNY'),
('', '', '', 'Auvergne', 'Allier (03)','03240', 'ROCLES'),
('', '', '', 'Auvergne', 'Allier (03)','03150', 'RONGERES'),
('', '', '', 'Auvergne', 'Allier (03)','03420', 'RONNET'),
('', '', '', 'Auvergne', 'Allier (03)','03170', 'SAINT ANGEL'),
('', '', '', 'Auvergne', 'Allier (03)','03160', 'SAINT AUBIN LE MONIAL'),
('', '', '', 'Auvergne', 'Allier (03)','03390', 'SAINT BONNET DE FOUR'),
('', '', '', 'Auvergne', 'Allier (03)','03800', 'SAINT BONNET DE ROCHEFORT'),
('', '', '', 'Auvergne', 'Allier (03)','03360', 'SAINT BONNET TRONCAIS'),
('', '', '', 'Auvergne', 'Allier (03)','03190', 'SAINT CAPRAIS'),
('', '', '', 'Auvergne', 'Allier (03)','03120', 'SAINT CHRISTOPHE'),
('', '', '', 'Auvergne', 'Allier (03)','03250', 'SAINT CLEMENT'),
('', '', '', 'Auvergne', 'Allier (03)','03370', 'SAINT DESIRE'),
('', '', '', 'Auvergne', 'Allier (03)','03130', 'SAINT DIDIER EN DONJON'),
('', '', '', 'Auvergne', 'Allier (03)','03110', 'SAINT DIDIER LA FORET'),
('', '', '', 'Auvergne', 'Allier (03)','03370', 'SAINT ELOY D''ALLIER'),
('', '', '', 'Auvergne', 'Allier (03)','03400', 'SAINT ENNEMOND'),
('', '', '', 'Auvergne', 'Allier (03)','03300', 'SAINT ETIENNE DE VICQ'),
('', '', '', 'Auvergne', 'Allier (03)','03420', 'SAINT FARGEOL'),
('', '', '', 'Auvergne', 'Allier (03)','03260', 'SAINT FELIX'),
('', '', '', 'Auvergne', 'Allier (03)','03310', 'SAINT GENEST'),
('', '', '', 'Auvergne', 'Allier (03)','03340', 'SAINT GERAND DE VAUX'),
('', '', '', 'Auvergne', 'Allier (03)','03150', 'SAINT GERAND LE PUY'),
('', '', '', 'Auvergne', 'Allier (03)','03140', 'SAINT GERMAIN DE SALLES'),
('', '', '', 'Auvergne', 'Allier (03)','03260', 'SAINT GERMAIN DES FOSSES'),
('', '', '', 'Auvergne', 'Allier (03)','03440', 'SAINT HILAIRE'),
('', '', '', 'Auvergne', 'Allier (03)','03130', 'SAINT LEGER SUR VOUZANCE'),
('', '', '', 'Auvergne', 'Allier (03)','03220', 'SAINT LEON'),
('', '', '', 'Auvergne', 'Allier (03)','03160', 'SAINT LEOPARDIN D''AUGY'),
('', '', '', 'Auvergne', 'Allier (03)','03150', 'SAINT LOUP'),
('', '', '', 'Auvergne', 'Allier (03)','03420', 'SAINT MARCEL EN MARCILLAT'),
('', '', '', 'Auvergne', 'Allier (03)','03390', 'SAINT MARCEL EN MURAT'),
('', '', '', 'Auvergne', 'Allier (03)','03230', 'SAINT MARTIN DES LAIS'),
('', '', '', 'Auvergne', 'Allier (03)','03380', 'SAINT MARTINIEN'),
('', '', '', 'Auvergne', 'Allier (03)','03210', 'SAINT MENOUX'),
('', '', '', 'Auvergne', 'Allier (03)','03250', 'SAINT NICOLAS DES BIEFS'),
('', '', '', 'Auvergne', 'Allier (03)','03370', 'SAINT PALAIS'),
('', '', '', 'Auvergne', 'Allier (03)','42620', 'SAINT PIERRE LAVAL'),
('', '', '', 'Auvergne', 'Allier (03)','03160', 'SAINT PLAISIR'),
('', '', '', 'Auvergne', 'Allier (03)','03110', 'SAINT PONT'),
('', '', '', 'Auvergne', 'Allier (03)','03290', 'SAINT POURCAIN SUR BESBRE'),
('', '', '', 'Auvergne', 'Allier (03)','03500', 'SAINT POURCAIN SUR SIOULE'),
('', '', '', 'Auvergne', 'Allier (03)','03800', 'SAINT PRIEST D''ANDELOT'),
('', '', '', 'Auvergne', 'Allier (03)','03390', 'SAINT PRIEST EN MURAT'),
('', '', '', 'Auvergne', 'Allier (03)','03120', 'SAINT PRIX'),
('', '', '', 'Auvergne', 'Allier (03)','03110', 'SAINT REMY EN ROLLAT'),
('', '', '', 'Auvergne', 'Allier (03)','03370', 'SAINT SAUVIER'),
('', '', '', 'Auvergne', 'Allier (03)','03240', 'SAINT SORNIN'),
('', '', '', 'Auvergne', 'Allier (03)','03420', 'SAINTE THERENCE'),
('', '', '', 'Auvergne', 'Allier (03)','03410', 'SAINT VICTOR'),
('', '', '', 'Auvergne', 'Allier (03)','03220', 'SAINT VOIR'),
('', '', '', 'Auvergne', 'Allier (03)','03270', 'SAINT YORRE'),
('', '', '', 'Auvergne', 'Allier (03)','03470', 'SALIGNY SUR ROUDON'),
('', '', '', 'Auvergne', 'Allier (03)','03150', 'SANSSAT'),
('', '', '', 'Auvergne', 'Allier (03)','03500', 'SAULCET'),
('', '', '', 'Auvergne', 'Allier (03)','03800', 'SAULZET'),
('', '', '', 'Auvergne', 'Allier (03)','03430', 'SAUVAGNY'),
('', '', '', 'Auvergne', 'Allier (03)','03390', 'SAZERET'),
('', '', '', 'Auvergne', 'Allier (03)','03700', 'SERBANNES'),
('', '', '', 'Auvergne', 'Allier (03)','03120', 'SERVILLY'),
('', '', '', 'Auvergne', 'Allier (03)','03260', 'SEUILLET'),
('', '', '', 'Auvergne', 'Allier (03)','03220', 'SORBIER'),
('', '', '', 'Auvergne', 'Allier (03)','03210', 'SOUVIGNY'),
('', '', '', 'Auvergne', 'Allier (03)','03450', 'SUSSAT'),
('', '', '', 'Auvergne', 'Allier (03)','03140', 'TARGET'),
('', '', '', 'Auvergne', 'Allier (03)','03140', 'TAXAT SENAT'),
('', '', '', 'Auvergne', 'Allier (03)','03410', 'TEILLET ARGENTY'),
('', '', '', 'Auvergne', 'Allier (03)','03420', 'TERJAT'),
('', '', '', 'Auvergne', 'Allier (03)','03240', 'THEIL (LE)'),
('', '', '', 'Auvergne', 'Allier (03)','03350', 'THENEUILLE'),
('', '', '', 'Auvergne', 'Allier (03)','03230', 'THIEL SUR ACOLIN'),
('', '', '', 'Auvergne', 'Allier (03)','03220', 'THIONNE'),
('', '', '', 'Auvergne', 'Allier (03)','03430', 'TORTEZAIS'),
('', '', '', 'Auvergne', 'Allier (03)','03400', 'TOULON SUR ALLIER'),
('', '', '', 'Auvergne', 'Allier (03)','03240', 'TREBAN'),
('', '', '', 'Auvergne', 'Allier (03)','03380', 'TREIGNAT'),
('', '', '', 'Auvergne', 'Allier (03)','03220', 'TRETEAU'),
('', '', '', 'Auvergne', 'Allier (03)','03460', 'TREVOL'),
('', '', '', 'Auvergne', 'Allier (03)','03220', 'TREZELLES'),
('', '', '', 'Auvergne', 'Allier (03)','03240', 'TRONGET'),
('', '', '', 'Auvergne', 'Allier (03)','03360', 'URCAY'),
('', '', '', 'Auvergne', 'Allier (03)','03140', 'USSEL D''ALLIER'),
('', '', '', 'Auvergne', 'Allier (03)','03330', 'VALIGNAT'),
('', '', '', 'Auvergne', 'Allier (03)','03360', 'VALIGNY'),
('', '', '', 'Auvergne', 'Allier (03)','03190', 'VALLON EN SULLY'),
('', '', '', 'Auvergne', 'Allier (03)','03150', 'VARENNES SUR ALLIER'),
('', '', '', 'Auvergne', 'Allier (03)','03220', 'VARENNES SUR TECHE'),
('', '', '', 'Auvergne', 'Allier (03)','03220', 'VAUMAS'),
('', '', '', 'Auvergne', 'Allier (03)','03190', 'VAUX'),
('', '', '', 'Auvergne', 'Allier (03)','03450', 'VEAUCE'),
('', '', '', 'Auvergne', 'Allier (03)','03190', 'VENAS'),
('', '', '', 'Auvergne', 'Allier (03)','03110', 'VENDAT'),
('', '', '', 'Auvergne', 'Allier (03)','03190', 'VERNEIX'),
('', '', '', 'Auvergne', 'Allier (03)','03200', 'VERNET (LE)'),
('', '', '', 'Auvergne', 'Allier (03)','03500', 'VERNEUIL EN BOURBONNAIS'),
('', '', '', 'Auvergne', 'Allier (03)','03390', 'VERNUSSE'),
('', '', '', 'Auvergne', 'Allier (03)','03320', 'VEURDRE (LE)'),
('', '', '', 'Auvergne', 'Allier (03)','03200', 'VICHY'),
('', '', '', 'Auvergne', 'Allier (03)','03450', 'VICQ'),
('', '', '', 'Auvergne', 'Allier (03)','03430', 'VIEURE'),
('', '', '', 'Auvergne', 'Allier (03)','03350', 'VILHAIN (LE)'),
('', '', '', 'Auvergne', 'Allier (03)','03310', 'VILLEBRET'),
('', '', '', 'Auvergne', 'Allier (03)','03430', 'VILLEFRANCHE D''ALLIER'),
('', '', '', 'Auvergne', 'Allier (03)','03460', 'VILLENEUVE SUR ALLIER'),
('', '', '', 'Auvergne', 'Allier (03)','03370', 'VIPLAIX'),
('', '', '', 'Auvergne', 'Allier (03)','03360', 'VITRAY'),
('', '', '', 'Auvergne', 'Allier (03)','03140', 'VOUSSAC'),
('', '', '', 'Auvergne', 'Allier (03)','03160', 'YGRANDE'),
('', '', '', 'Auvergne', 'Allier (03)','03400', 'YZEURE'),
('', '0', '', 'Auvergne',   'Allier (03)', '', 'AUTRE VILLE DU 03'),




('', '', '', 'Auvergne', 'Cantal (15)', '15300', 'ALBEPIERRE BREDONS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15160', 'ALLANCHE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'ALLEUZE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15700', 'ALLY'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'ANDELAT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'ANGLARDS DE SAINT FLOUR'),
('', '', '', 'Auvergne', 'Cantal (15)', '15380', 'ANGLARDS DE SALERS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15110', 'ANTERRIEUX'),
('', '', '', 'Auvergne', 'Cantal (15)', '15240', 'ANTIGNAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15400', 'APCHON'),
('', '', '', 'Auvergne', 'Cantal (15)', '15200', 'ARCHES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15150', 'ARNAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15130', 'ARPAJON SUR CERE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15500', 'AURIAC L''EGLISE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15000', 'AURILLAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15240', 'AUZERS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15250', 'AYRENS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15800', 'BADAILHAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15700', 'BARRIAC LES BOSQUETS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15240', 'BASSIGNAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15270', 'BEAULIEU'),
('', '', '', 'Auvergne', 'Cantal (15)', '15140', 'BESSE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15600', 'BOISSET'),
('', '', '', 'Auvergne', 'Cantal (15)', '15500', 'BONNAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15700', 'BRAGEAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15230', 'BREZONS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15340', 'CALVINET'),
('', '', '', 'Auvergne', 'Cantal (15)', '43450', 'LEYVAUX'),
('', '', '', 'Auvergne', 'Cantal (15)', '15130', 'CARLAT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15340', 'CASSANIOUZE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15290', 'CAYROLS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15170', 'CELLES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15500', 'CELOUX'),
('', '', '', 'Auvergne', 'Cantal (15)', '15230', 'CEZENS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15320', 'CHALIERS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15170', 'CHALINARGUES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15200', 'CHALVIGNAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15350', 'CHAMPAGNAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15270', 'CHAMPS SUR TARENTAINE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15190', 'CHANTERELLE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15300', 'CHAPELLE D''ALAGNON (LA)'),
('', '', '', 'Auvergne', 'Cantal (15)', '15500', 'CHAPELLE LAURENT (LA)'),
('', '', '', 'Auvergne', 'Cantal (15)', '15500', 'CHARMENSAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15300', 'CHASTEL SUR MURAT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15110', 'CHAUDES AIGUES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15700', 'CHAUSSENAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15300', 'CHAVAGNAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15500', 'CHAZELLES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15400', 'CHEYLADE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15400', 'CLAUX (LE)'),
('', '', '', 'Auvergne', 'Cantal (15)', '15320', 'CLAVIERES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15400', 'COLLANDRES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15170', 'COLTINES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15190', 'CONDAT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'COREN'),
('', '', '', 'Auvergne', 'Cantal (15)', '15250', 'CRANDELLES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15150', 'CROS DE MONTVERT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15130', 'CROS DE RONESQUE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15430', 'CUSSAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15110', 'DEUX VERGES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15300', 'DIENNE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15140', 'DRUGEAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15700', 'ESCORAILLES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15110', 'ESPINASSE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15380', 'FALGOUX (LE)'),
('', '', '', 'Auvergne', 'Cantal (15)', '15140', 'FAU (LE)'),
('', '', '', 'Auvergne', 'Cantal (15)', '15320', 'FAVEROLLES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15170', 'FERRIERES SAINT MARY'),
('', '', '', 'Auvergne', 'Cantal (15)', '15140', 'FONTANGES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15600', 'FOURNOULES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15310', 'FREIX ANGLARDS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15110', 'FRIDEFONT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15130', 'GIOU DE MAMOU'),
('', '', '', 'Auvergne', 'Cantal (15)', '15310', 'GIRGOLS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15150', 'GLENAT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15230', 'GOURDIEGES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15110', 'JABRUN'),
('', '', '', 'Auvergne', 'Cantal (15)', '15200', 'JALEYRAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15800', 'JOU SOUS MONJOU'),
('', '', '', 'Auvergne', 'Cantal (15)', '15170', 'JOURSAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15120', 'JUNHAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15250', 'JUSSAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15120', 'LABESSERETTE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15130', 'LABROUSSE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15230', 'LACAPELLE BARRES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15120', 'LACAPELLE DEL FRAISSE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15150', 'LACAPELLE VIESCAMP'),
('', '', '', 'Auvergne', 'Cantal (15)', '15120', 'LADINHAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15130', 'LAFEUILLADE EN VEZIE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15160', 'LANDEYRAT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15270', 'LANOBRE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15120', 'LAPEYRUGUE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15150', 'LAROQUEBROU'),
('', '', '', 'Auvergne', 'Cantal (15)', '15250', 'LAROQUEVIEILLE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15590', 'LASCELLE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15500', 'LASTIC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15500', 'LAURIE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15260', 'LAVASTRIE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15300', 'LAVEISSENET'),
('', '', '', 'Auvergne', 'Cantal (15)', '15300', 'LAVEISSIERE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15300', 'LAVIGERIE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15120', 'LEUCAMP'),
('', '', '', 'Auvergne', 'Cantal (15)', '15600', 'LEYNHAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15110', 'LIEUTADES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15320', 'LORCIERES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15320', 'LOUBARESSE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15190', 'LUGARDE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15210', 'MADIC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15230', 'MALBO'),
('', '', '', 'Auvergne', 'Cantal (15)', '15590', 'MANDAILLES SAINT JULIEN'),
('', '', '', 'Auvergne', 'Cantal (15)', '15190', 'MARCENAT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15400', 'MARCHASTEL'),
('', '', '', 'Auvergne', 'Cantal (15)', '15220', 'MARCOLES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15250', 'MARMANHAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15500', 'MASSIAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15200', 'MAURIAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15110', 'MAURINES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15600', 'MAURS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15200', 'MEALLET'),
('', '', '', 'Auvergne', 'Cantal (15)', '15400', 'MENET'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'MENTIERES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15500', 'MOLEDES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15500', 'MOLOMPIZE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15240', 'MONSELIE (LA)'),
('', '', '', 'Auvergne', 'Cantal (15)', '15190', 'MONTBOUDIF'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'MONTCHAMP'),
('', '', '', 'Auvergne', 'Cantal (15)', '15240', 'MONTEIL (LE)'),
('', '', '', 'Auvergne', 'Cantal (15)', '15190', 'MONTGRELEIX'),
('', '', '', 'Auvergne', 'Cantal (15)', '15600', 'MONTMURAT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15120', 'MONTSALVY'),
('', '', '', 'Auvergne', 'Cantal (15)', '15150', 'MONTVERT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15340', 'MOURJOU'),
('', '', '', 'Auvergne', 'Cantal (15)', '15380', 'MOUSSAGES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15300', 'MURAT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15230', 'NARNHAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15250', 'NAUCELLES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15000', 'NAUCELLES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15170', 'NEUSSARGUES MOISSAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15260', 'NEUVEGLISE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15150', 'NIEUDAN'),
('', '', '', 'Auvergne', 'Cantal (15)', '15290', 'OMPS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15260', 'ORADOUR'),
('', '', '', 'Auvergne', 'Cantal (15)', '15800', 'PAILHEROLS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15290', 'PARLAN'),
('', '', '', 'Auvergne', 'Cantal (15)', '15430', 'PAULHAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15230', 'PAULHENC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15290', 'PERS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15170', 'PEYRUSSE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15230', 'PIERREFORT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15700', 'PLEAUX'),
('', '', '', 'Auvergne', 'Cantal (15)', '15800', 'POLMINHAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15160', 'PRADIERS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15130', 'PRUNET'),
('', '', '', 'Auvergne', 'Cantal (15)', '15600', 'QUEZAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15500', 'RAGEADE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15800', 'RAULHAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15250', 'REILHAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15170', 'REZENTIERES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15400', 'RIOM ES MONTAGNES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15220', 'ROANNES SAINT MARY'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'ROFFIAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15150', 'ROUFFIAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15290', 'ROUGET (LE)'),
('', '', '', 'Auvergne', 'Cantal (15)', '15290', 'ROUMEGOUX'),
('', '', '', 'Auvergne', 'Cantal (15)', '15600', 'ROUZIERS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15320', 'RUYNES EN MARGERIDE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15240', 'SAIGNES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15190', 'SAINT AMANDIN'),
('', '', '', 'Auvergne', 'Cantal (15)', '15170', 'SAINTE ANASTASIE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15220', 'SAINT ANTOINE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15190', 'SAINT BONNET DE CONDAT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15140', 'SAINT BONNET DE SALERS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15310', 'SAINT CERNIN'),
('', '', '', 'Auvergne', 'Cantal (15)', '15140', 'SAINT CHAMANT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15590', 'SAINT CIRGUES DE JORDANNE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15140', 'SAINT CIRGUES DE MALBERT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15800', 'SAINT CLEMENT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15600', 'SAINT CONSTANT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15150', 'SAINT ETIENNE CANTALES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15130', 'SAINT ETIENNE DE CARLAT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15400', 'SAINT ETIENNE DE CHOMEIL'),
('', '', '', 'Auvergne', 'Cantal (15)', '15600', 'SAINT ETIENNE DE MAURS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15140', 'SAINTE EULALIE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'SAINT FLOUR'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'SAINT GEORGES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15150', 'SAINT GERONS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15400', 'SAINT HIPPOLYTE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15310', 'SAINT ILLIDE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15800', 'SAINT JACQUES DES BLATS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15600', 'SAINT JULIEN DE TOURSAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15320', 'SAINT JUST'),
('', '', '', 'Auvergne', 'Cantal (15)', '15220', 'SAINT MAMET LA SALVETAT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15320', 'SAINT MARC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15230', 'SAINTE MARIE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15110', 'SAINT MARTIAL'),
('', '', '', 'Auvergne', 'Cantal (15)', '15140', 'SAINT MARTIN CANTALES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15230', 'SAINT MARTIN SOUS VIGOUROUX'),
('', '', '', 'Auvergne', 'Cantal (15)', '15140', 'SAINT MARTIN VALMEROUX'),
('', '', '', 'Auvergne', 'Cantal (15)', '15500', 'SAINT MARY LE PLAIN'),
('', '', '', 'Auvergne', 'Cantal (15)', '15140', 'SAINT PAUL DE SALERS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15250', 'SAINT PAUL DES LANDES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15350', 'SAINT PIERRE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15500', 'SAINT PONCY'),
('', '', '', 'Auvergne', 'Cantal (15)', '15140', 'SAINT PROJET DE SALERS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15110', 'SAINT REMY DE CHAUDES AIGUES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15150', 'SAINT SANTIN CANTALES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15600', 'SAINT SANTIN DE MAURS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15190', 'SAINT SATURNIN'),
('', '', '', 'Auvergne', 'Cantal (15)', '15290', 'SAINT SAURY'),
('', '', '', 'Auvergne', 'Cantal (15)', '15130', 'SAINT SIMON'),
('', '', '', 'Auvergne', 'Cantal (15)', '15110', 'SAINT URCIZE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15150', 'SAINT VICTOR'),
('', '', '', 'Auvergne', 'Cantal (15)', '15380', 'SAINT VINCENT DE SALERS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15140', 'SALERS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15200', 'SALINS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15130', 'SANSAC DE MARMIESSE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15120', 'SANSAC VEINAZES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15240', 'SAUVAT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15290', 'SEGALASSIERE (LA)'),
('', '', '', 'Auvergne', 'Cantal (15)', '15300', 'SEGUR LES VILLAS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15340', 'SENEZERGUES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'SERIERS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15150', 'SIRAN'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'SOULAGES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15200', 'SOURNIAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15170', 'TALIZAT'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'TANAVELLE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15250', 'TEISSIERES DE CORNET'),
('', '', '', 'Auvergne', 'Cantal (15)', '15130', 'TEISSIERES LES BOULIES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'TERNES (LES)'),
('', '', '', 'Auvergne', 'Cantal (15)', '15800', 'THIEZAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'TIVIERS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15310', 'TOURNEMIRE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15270', 'TREMOUILLE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15110', 'TRINITAT (LA)'),
('', '', '', 'Auvergne', 'Cantal (15)', '15600', 'TRIOULOU (LE)'),
('', '', '', 'Auvergne', 'Cantal (15)', '15400', 'TRIZAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15300', 'USSEL'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'VABRES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15400', 'VALETTE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15170', 'VALJOUZE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15300', 'VALUEJOLS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15380', 'VAULMIER (LE)'),
('', '', '', 'Auvergne', 'Cantal (15)', '15240', 'VEBRET'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'VEDRINES SAINT LOUP'),
('', '', '', 'Auvergne', 'Cantal (15)', '15590', 'VELZIC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15160', 'VERNOLS'),
('', '', '', 'Auvergne', 'Cantal (15)', '15350', 'VEYRIERES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15130', 'VEZAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15160', 'VEZE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15130', 'VEZELS ROUSSY'),
('', '', '', 'Auvergne', 'Cantal (15)', '15800', 'VIC SUR CERE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15500', 'VIEILLESPESSE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15120', 'VIEILLEVIE'),
('', '', '', 'Auvergne', 'Cantal (15)', '15200', 'VIGEAN (LE)'),
('', '', '', 'Auvergne', 'Cantal (15)', '15100', 'VILLEDIEU'),
('', '', '', 'Auvergne', 'Cantal (15)', '15300', 'VIRARGUES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15220', 'VITRAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15210', 'YDES'),
('', '', '', 'Auvergne', 'Cantal (15)', '15130', 'YOLET'),
('', '', '', 'Auvergne', 'Cantal (15)', '15130', 'YTRAC'),
('', '', '', 'Auvergne', 'Cantal (15)', '15000', 'YTRAC'),
('', '0', '', 'Auvergne',   'Cantal (15)', '', 'AUTRE VILLE DU 15'),





('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'AGNAT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43000', 'AIGUILHE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43270', 'ALLEGRE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43150', 'ALLEYRAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43580', 'ALLEYRAS'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43380', 'ALLY'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43200', 'ARAULES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43490', 'ARLEMPDES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43380', 'ARLET'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43700', 'ARSAC EN VELAY'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43380', 'AUBAZAT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43110', 'AUREC SUR LOIRE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43450', 'AUTRAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'AUVERS'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43390', 'AUZON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43390', 'AZERAT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43370', 'BAINS'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43340', 'BARGES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43210', 'BAS EN BASSET'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43800', 'BEAULIEU'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'BEAUMONT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43500', 'BEAUNE SUR ARZON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43200', 'BEAUX'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43590', 'BEAUZAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43350', 'BELLEVUE LA MONTAGNE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43160', 'BERBEZIT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43200', 'BESSAMOREL'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43170', 'BESSEYRE SAINT MARY (LA)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43350', 'BLANZAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43380', 'BLASSAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43700', 'BLAVOZY'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43450', 'BLESLE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43500', 'BOISSET'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43160', 'BONNEVAL'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43350', 'BORNE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43510', 'BOUCHET SAINT NICOLAS (LE)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43360', 'BOURNONCLE SAINT PIERRE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43370', 'BRIGNON (LE)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'BRIOUDE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43700', 'BRIVES CHARENSAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43510', 'CAYRES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43270', 'CEAUX D''ALLEGRE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43380', 'CERZAT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43000', 'CEYSSAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43770', 'CHADRAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43150', 'CHADRON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43160', 'CHAISE DIEU (LA)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43800', 'CHAMALIERES SUR LOIRE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43410', 'CHAMBEZON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43400', 'CHAMBON SUR LIGNON (LE)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43440', 'CHAMPAGNAC LE VIEUX'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43260', 'CHAMPCLAUSE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43430', 'CHAMPCLAUSE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43170', 'CHANALEILLES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'CHANIAT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'CHANTEUGES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43270', 'CHAPELLE BERTIN (LA)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43120', 'CHAPELLE D''AUREC (LA)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43160', 'CHAPELLE GENESTE (LA)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'CHARRAIX'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43700', 'CHASPINHAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43320', 'CHASPUZAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'CHASSAGNES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43440', 'CHASSIGNOLLES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'CHASTEL'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43430', 'CHAUDEYROLLES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'CHAVANIAC LAFAYETTE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'CHAZELLES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43190', 'CHENEREILLES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43380', 'CHILHAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43500', 'CHOMELIX'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'CHOMETTE (LA)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43160', 'CISTRIERES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'COHADE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'COLLAT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43160', 'CONNANGLES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43490', 'COSTAROS'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43700', 'COUBON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'COUTEUGES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43500', 'CRAPONNE SUR ARZON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43580', 'CROISANCES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'CRONCE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43170', 'CUBELLES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43370', 'CUSSAC SUR LOIRE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'DESGES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'DOMEYRAT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43220', 'DUNIERES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43450', 'ESPALEM'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43000', 'ESPALY SAINT MARCEL'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43170', 'ESPLANTAS'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43150', 'ESTABLES (LES)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43430', 'FAY SUR LIGNON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43160', 'FELINES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'FERRUSSAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43320', 'FIX SAINT GENEYS'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'FONTANNES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43150', 'FREYCENET LA CUCHE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43150', 'FREYCENET LA TOUR'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43250', 'FRUGERES LES MINES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'FRUGIERES LE PIN'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43150', 'GOUDET'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43200', 'GRAZAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43450', 'GRENIER MONTGON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43170', 'GREZES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'JAVAUGUES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'JAX'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'JOSAT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43500', 'JULLIANGES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43490', 'LAFARRE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'LAMOTHE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43340', 'LANDOS'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'LANGEAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43260', 'LANTRIAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43200', 'LAPTE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43150', 'LAUSSONNE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43440', 'LAVAL SUR DOULON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'LAVAUDIEU'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43380', 'LAVOUTE CHILHAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43800', 'LAVOUTE SUR LOIRE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43410', 'LEMPDES SUR ALLAGNON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43410', 'LEOTOING'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43350', 'LISSAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43360', 'LORLANGES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43320', 'LOUDES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'LUBILHAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43800', 'MALREVERS'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43210', 'MALVALETTE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43160', 'MALVIERES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43190', 'MAS DE TENCE (LE)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'MAZERAT AUROUZE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43520', 'MAZET SAINT VOY'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'MAZEYRAT D''ALLIER'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'MERCOEUR'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43800', 'MEZERES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43150', 'MONASTIER SUR GAZEILLE (LE)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43580', 'MONISTROL D''ALLIER'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43120', 'MONISTROL SUR LOIRE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43270', 'MONLET'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'MONTCLARD'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43700', 'MONTEIL (LE)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43290', 'MONTFAUCON EN VELAY'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43290', 'MONTREGARD'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43260', 'MONTUSCLAT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43150', 'MOUDEYRES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43510', 'OUIDES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'PAULHAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'PAULHAGUET'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'PEBRAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43200', 'PERTUIS (LE)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'PINOLS'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43000', 'POLIGNAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43330', 'PONT SALOMON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43420', 'PRADELLES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'PRADES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43150', 'PRESAILLES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43000', 'PUY EN VELAY (LE)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43260', 'QUEYRIERES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43290', 'RAUCOULES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43340', 'RAURET'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43130', 'RETOURNAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43220', 'RIOTORD'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43810', 'ROCHE EN REGNIER'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43800', 'ROSIERES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43130', 'SAINT ANDRE DE CHALENCON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'SAINT ARCONS D''ALLIER'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43420', 'SAINT ARCONS DE BARGES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43380', 'SAINT AUSTREMOINE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'SAINT BEAUZIRE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'SAINT BERAIN'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43290', 'SAINT BONNET LE FROID'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43340', 'SAINT CHRISTOPHE D''ALLIER'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43370', 'SAINT CHRISTOPHE SUR DOLAISON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43380', 'SAINT CIRGUES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43580', 'SAINT DIDIER D''ALLIER'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43140', 'SAINT DIDIER EN VELAY'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43440', 'SAINT DIDIER SUR DOULON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43420', 'SAINT ETIENNE DU VIGAN'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43260', 'SAINT ETIENNE LARDEYROL'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43450', 'SAINT ETIENNE SUR BLESLE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'SAINTE EUGENIE DE VILLENEUVE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43330', 'SAINT FERREOL D''AUROURE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43250', 'SAINTE FLORINE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43550', 'SAINT FRONT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43350', 'SAINT GENEYS PRES SAINT PAULIEN'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'SAINT GEORGES D''AURAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43500', 'SAINT GEORGES LAGRICOL'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43700', 'SAINT GERMAIN LAPRADE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43360', 'SAINT GERON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43340', 'SAINT HAON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43390', 'SAINT HILAIRE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43260', 'SAINT HOSTIEN'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43380', 'SAINT ILPIZE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43500', 'SAINT JEAN D''AUBRIGOUX'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43320', 'SAINT JEAN DE NAY'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43510', 'SAINT JEAN LACHALM'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43200', 'SAINT JEURES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43260', 'SAINT JULIEN CHAPTEUIL'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43500', 'SAINT JULIEN D''ANCE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'SAINT JULIEN DES CHAZES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43200', 'SAINT JULIEN DU PINET'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43220', 'SAINT JULIEN MOLHESABATE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43240', 'SAINT JUST MALMONT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'SAINT JUST PRES BRIOUDE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'SAINT LAURENT CHABREUGES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'SAINTE MARGUERITE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43150', 'SAINT MARTIN DE FUGERES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43120', 'SAINT MAURICE DE LIGNON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43200', 'SAINT MAURICE DE LIGNON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43500', 'SAINT PAL DE CHALENCON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43620', 'SAINT PAL DE MONS'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43160', 'SAINT PAL DE SENOUIRE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43420', 'SAINT PAUL DE TARTAS'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43350', 'SAINT PAULIEN'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43130', 'SAINT PIERRE DU CHAMP'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43260', 'SAINT PIERRE EYNAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'SAINT PREJET ARMANDON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43580', 'SAINT PREJET D''ALLIER'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43580', 'SAINT PRIVAT D''ALLIER'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43380', 'SAINT PRIVAT DU DRAGON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43620', 'SAINT ROMAIN LACHALM'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43600', 'SAINTE SIGOLENE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43580', 'SAINT VENERAND'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43440', 'SAINT VERT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43140', 'SAINT VICTOR MALESCOURS'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43500', 'SAINT VICTOR SUR ARLANC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43320', 'SAINT VIDAL'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43800', 'SAINT VINCENT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43150', 'SALETTES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'SALZUIT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43320', 'SANSSAC L''EGLISE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43170', 'SAUGUES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43140', 'SEAUVE SUR SEMENE (LA)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43160', 'SEMBADEL'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43510', 'SENEUJOLS'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'SIAUGUES SAINTE MARIE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43130', 'SOLIGNAC SOUS ROCHE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43370', 'SOLIGNAC SUR LOIRE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'TAILHAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43190', 'TENCE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43170', 'THORAS'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43130', 'TIRANGES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43450', 'TORSIAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43210', 'VALPRIVAS'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43230', 'VALS LE CHASTEL'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43750', 'VALS PRES LE PUY'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43270', 'VARENNES SAINT HONORAT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43430', 'VASTRES (LES)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43320', 'VAZEILLES LIMANDRE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43580', 'VAZEILLES PRES SAUGUES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43170', 'VENTEUGES'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43320', 'VERGEZAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43360', 'VERGONGHEON'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43270', 'VERNASSAL'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43320', 'VERNET (LE)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43390', 'VEZEZOUX'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43100', 'VIEILLE BRIOUDE'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43490', 'VIELPRAT'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43380', 'VILLENEUVE D''ALLIER'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43600', 'VILLETTES (LES)'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43300', 'VISSAC AUTEYRAC'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43800', 'VOREY'),
('', '', '', 'Auvergne',  'Haute-Loire (43) ', '43200', 'YSSINGEAUX'),
('', '0', '', 'Auvergne',   'Haute-Loire (43)', '', 'AUTRE VILLE DU 43'),




('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63260', 'AIGUEPERSE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63980', 'AIX LA FAYETTE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63600', 'AMBERT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63770', 'ANCIZES COMPS (LES)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'ANTOINGT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63420', 'ANZAT LE LUGUET'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63420', 'APCHAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63250', 'ARCONSAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63420', 'ARDES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63220', 'ARLANC'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63700', 'ARS LES FAVETS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63460', 'ARTONNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63260', 'AUBIAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63170', 'AUBIERE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63120', 'AUBUSSON D''AUVERGNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63930', 'AUGEROLLES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'AUGNAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'AULHAT SAINT PRIVAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63510', 'AULNAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63210', 'AURIERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63114', 'AUTHEZAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63570', 'AUZAT LA COMBELLE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63590', 'AUZELLES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63690', 'AVEZE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63390', 'AYAT SUR SIOULE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63970', 'AYDAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63600', 'BAFFIE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63810', 'BAGNOLS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63570', 'BANSAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63310', 'BAS ET LEZAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63570', 'BEAULIEU'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63110', 'BEAUMONT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63170', 'BEAUMONT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63310', 'BEAUMONT LES RANDAN'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63116', 'BEAUREGARD L''EVEQUE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63460', 'BEAUREGARD VENDON'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'BERGONNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63480', 'BERTIGNAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63610', 'BESSE ET SAINT ANASTAISE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63220', 'BEURRIERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63160', 'BILLOM'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63640', 'BIOLLET'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63112', 'BLANZAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63440', 'BLOT L''EGLISE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63160', 'BONGHEAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63190', 'BORT L''ETANG'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'BOUDES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63150', 'BOURBOULE (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63760', 'BOURG LASTIC'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63910', 'BOUZEL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63570', 'BRASSAC LES MINES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'BRENAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'BREUIL SUR COUZE (LE)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63820', 'BRIFFONS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'BROC (LE)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63230', 'BROMONT LAMOTHE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63490', 'BROUSSE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63880', 'BRUGERON (LE)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63350', 'BULHON'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63270', 'BUSSEOL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63260', 'BUSSIERES ET PRUNS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63330', 'BUSSIERES PRES PIONSAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63700', 'BUXIERES SOUS MONTAIGUT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63118', 'CEBAZAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63520', 'CEILLOUX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63620', 'CELLE (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63250', 'CELLES SUR DUROLLE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63330', 'CELLETTE (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63200', 'CELLULE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63670', 'CENDRE (LE)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63122', 'CEYRAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63210', 'CEYSSAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63250', 'CHABRELOCHE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'CHADELEUF'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'CHALUS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63400', 'CHAMALIERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63980', 'CHAMBON SUR DOLORE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63790', 'CHAMBON SUR LAC'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63580', 'CHAMEANE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63580', 'CHAMPAGNAT LE JEUNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'CHAMPEIX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63600', 'CHAMPETIERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63440', 'CHAMPS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63530', 'CHANAT LA MOUTEYRE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63450', 'CHANONAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63230', 'CHAPDES BEAUFORT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63590', 'CHAPELLE AGNON (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63420', 'CHAPELLE MARCOUSSE (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63580', 'CHAPELLE SUR USSON'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63720', 'CHAPPES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63260', 'CHAPTUZAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'CHARBONNIER LES MINES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63410', 'CHARBONNIERES LES VARENNES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63410', 'CHARBONNIERES LES VIEILLES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63640', 'CHARENSAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63290', 'CHARNAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63160', 'CHAS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'CHASSAGNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63680', 'CHASTREIX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63330', 'CHATEAU SUR CHER'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63119', 'CHATEAUGAY'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63390', 'CHATEAUNEUF LES BAINS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63140', 'CHATEL GUYON'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63290', 'CHATELDON'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63660', 'CHAULME (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63220', 'CHAUMONT LE BOURG'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63117', 'CHAURIAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63720', 'CHAVAROUX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63200', 'CHEIX (LE)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'CHIDRAC'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63740', 'CISTERNES LA FORET'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'CLEMENSAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63720', 'CLERLANDE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63000', 'CLERMONT FERRAND'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63100', 'CLERMONT FERRAND'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'COLLANGES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63380', 'COMBRAILLES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63460', 'COMBRONDE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63610', 'COMPAINS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63380', 'CONDAT EN COMBRAILLE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63490', 'CONDAT LES MONTBOISSIER'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63730', 'CORENT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63114', 'COUDES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'COURGOUL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63450', 'COURNOLS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63800', 'COURNON D''AUVERGNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63120', 'COURPIERE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63450', 'CREST (LE)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'CRESTE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63350', 'CREVANT LAVEINE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63810', 'CROS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63700', 'CROUZILLE (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63350', 'CULHAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63590', 'CUNLHAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63111', 'DALLET'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'DAUZAT SUR VODABLE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63200', 'DAVAYAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63520', 'DOMAIZE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63220', 'DORANGES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63300', 'DORAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63220', 'DORE L''EGLISE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63700', 'DURMIGNAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63830', 'DURTOL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63980', 'ECHANDELYS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63260', 'EFFIAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63850', 'EGLISENEUVE D''ENTRAIGUES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63490', 'EGLISENEUVE DES LIARDS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63160', 'EGLISENEUVE PRES BILLOM'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63840', 'EGLISOLLES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63720', 'ENNEZAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63720', 'ENTRAIGUES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63530', 'ENVAL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63300', 'ESCOUTOUX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63390', 'ESPINASSE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63850', 'ESPINCHAL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63160', 'ESPIRAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63520', 'ESTANDEUIL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63570', 'ESTEIL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63160', 'FAYET LE CHATEAU'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63630', 'FAYET RONAYE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63620', 'FERNOEL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'FLAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63600', 'FORIE (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63980', 'FOURNOLS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63740', 'GELLES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63360', 'GERZAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63620', 'GIAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'GIGNAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63200', 'GIMEAUX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63160', 'GLAINE MONTAIGUT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63850', 'GODIVELLE (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63230', 'GOUTELLE (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63390', 'GOUTTIERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'GRANDEYROLLES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63600', 'GRANDRIF'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63890', 'GRANDVAL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63470', 'HERMENT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63210', 'HEUME L''EGLISE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63270', 'ISSERTEAUX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'ISSOIRE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63990', 'JOB'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63350', 'JOZE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63460', 'JOSERAND'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63570', 'JUMEAUX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63690', 'LABESSETTE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63290', 'LACHAUX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63570', 'LAMONTGIE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63380', 'LANDOGNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63700', 'LAPEYROUSE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63270', 'LAPS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63820', 'LAQUEUILLE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63690', 'LARODDE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63760', 'LASTIC'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63370', 'LEMPDES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63190', 'LEMPTY'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63190', 'LEZOUX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63290', 'LIMONS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63440', 'LISSEUIL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63410', 'LOUBEYRAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'LUDESSE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63360', 'LUSSAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63350', 'LUZILLAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'MADRIAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63200', 'MALAUZAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63510', 'MALINTRAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63270', 'MANGLIEU'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63410', 'MANZAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63480', 'MARAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63440', 'MARCILLAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'MAREUGHEOL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63350', 'MARINGUES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63940', 'MARSAC EN LIVRADOIS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63200', 'MARSAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63430', 'MARTRES D''ARTIERE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63730', 'MARTRES DE VEYRE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63720', 'MARTRES SUR MORGE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63160', 'MAUZUN'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63220', 'MAYRES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63230', 'MAZAYES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63420', 'MAZOIRES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63220', 'MEDEYROLLES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'MEILHAUD'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63560', 'MENAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63200', 'MENETROL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63750', 'MESSEIX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63115', 'MEZEL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63730', 'MIREFLEURS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63380', 'MIREMONT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63190', 'MOISSAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63890', 'MONESTIER (LE)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63650', 'MONNERIE LE MONTEL (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63310', 'MONS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63240', 'MONT DORE (LE)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63700', 'MONTAIGUT EN COMBRAILLE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'MONTAIGUT LE BLANC'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63460', 'MONTCEL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63380', 'MONTEL DE GELAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63230', 'MONTFERMY'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63160', 'MONTMORIN'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63260', 'MONTPENSIER'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63114', 'MONTPEYROUX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'MORIAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63700', 'MOUREUILLE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63200', 'MOUTADE (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63200', 'MOZAC'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63150', 'MURAT LE QUAIRE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63790', 'MUROL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63210', 'NEBOUZAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63120', 'NERONDE SUR DORE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'NESCHERS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63560', 'NEUF EGLISE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63160', 'NEUVILLE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63290', 'NOALHAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63830', 'NOHANENT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'NONETTE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63220', 'NOVACELLES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63210', 'OLBY'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63880', 'OLLIERGUES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63450', 'OLLOIX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63880', 'OLMET'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'ORBEIL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63670', 'ORCET'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63870', 'ORCINES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63210', 'ORCIVAL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63190', 'ORLEAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'ORSONNETTE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63550', 'PALLADUC'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'PARDINES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63270', 'PARENT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'PARENTIGNAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63290', 'PASLIERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63170', 'PERIGNAT LES SARLIEVE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63800', 'PERIGNAT SUR ALLIER'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63210', 'PERPEZAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'PERRIER'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63920', 'PESCHADOIRES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63580', 'PESLIERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63200', 'PESSAT VILLENEUVE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63113', 'PICHERANDE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63270', 'PIGNOLS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63330', 'PIONSAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63730', 'PLAUZAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63430', 'PONT DU CHATEAU'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63380', 'PONTAUMUR'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63230', 'PONTGIBAUD'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63440', 'POUZOL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'PRADEAUX (LES)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63200', 'PROMPSAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63470', 'PRONDINES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63230', 'PULVERIERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63290', 'PUY GUILLAUME'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63470', 'PUY SAINT GULMIER'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63330', 'QUARTIER (LE)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63780', 'QUEUILLE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63310', 'RANDAN'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63190', 'RAVEL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63160', 'REIGNAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63930', 'RENAUDIE (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63420', 'RENTIERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63200', 'RIOM'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63290', 'RIS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63670', 'ROCHE BLANCHE (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63420', 'ROCHE CHARLES LA MAYRAND'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63330', 'ROCHE D''AGOUX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63800', 'ROCHE NOIRE (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63210', 'ROCHEFORT MONTAGNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63540', 'ROMAGNAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63130', 'ROYAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63840', 'SAILLANT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63120', 'SAINTE AGATHE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63260', 'SAINT AGOULIN'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63220', 'SAINT ALYRE D''ARLANC'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63420', 'SAINT ALYRE ES MONTAGNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63890', 'SAINT AMANT ROCHE SAVINE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63450', 'SAINT AMANT TALLENDE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63310', 'SAINT ANDRE LE COQ'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63410', 'SAINT ANGEL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63660', 'SAINT ANTHEME'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63380', 'SAINT AVIT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'SAINT BABEL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63360', 'SAINT BEAUZIRE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63630', 'SAINT BONNET LE BOURG'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63630', 'SAINT BONNET LE CHASTEL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63800', 'SAINT BONNET LES ALLIER'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63210', 'SAINT BONNET PRES ORCIVAL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63200', 'SAINT BONNET PRES RIOM'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63580', 'SAINTE CATHERINE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63390', 'SAINTE CHRISTINE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'SAINT CIRGUES SUR COUZE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63310', 'SAINT CLEMENT DE REGNAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63660', 'SAINT CLEMENT DE VALORGUE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63310', 'SAINT DENIS COMBARNAZAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63520', 'SAINT DIER D''AUVERGNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'SAINT DIERY'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63680', 'SAINT DONAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63890', 'SAINT ELOY LA GLACIERE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63700', 'SAINT ELOY LES MINES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63380', 'SAINT ETIENNE DES CHAMPS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63580', 'SAINT ETIENNE SUR USSON'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63600', 'SAINT FERREOL DES COTES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'SAINT FLORET'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63520', 'SAINT FLOUR L''ETANG'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63440', 'SAINT GAL SUR SIOULE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63122', 'SAINT GENES CHAMPANELLE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63850', 'SAINT GENES CHAMPESPE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63260', 'SAINT GENES DU RETZ'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63580', 'SAINT GENES LA TOURETTE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63780', 'SAINT GEORGES DE MONS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63800', 'SAINT GEORGES SUR ALLIER'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'SAINT GERMAIN LEMBRON'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63630', 'SAINT GERMAIN L''HERM'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63470', 'SAINT GERMAIN PRES HERMENT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63390', 'SAINT GERVAIS D''AUVERGNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63880', 'SAINT GERVAIS SOUS MEYMONT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'SAINT GERVAZY'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'SAINT HERENT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63440', 'SAINT HILAIRE LA CROIX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63380', 'SAINT HILAIRE LES MONGES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63330', 'SAINT HILAIRE PRES PIONSAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63720', 'SAINT IGNAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63230', 'SAINT JACQUES D''AMBUR'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63520', 'SAINT JEAN DES OLLIERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63190', 'SAINT JEAN D''HEURS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63490', 'SAINT JEAN EN VAL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63570', 'SAINT JEAN SAINT GERVAIS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63160', 'SAINT JULIEN DE COPPEL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63390', 'SAINT JULIEN LA GENESTE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63820', 'SAINT JULIEN PUY LAVEZE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63600', 'SAINT JUST'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63350', 'SAINT LAURE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63330', 'SAINT MAIGNER'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63600', 'SAINT MARTIN DES OLMES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63570', 'SAINT MARTIN DES PLAINS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63580', 'SAINT MARTIN D''OLLIERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63270', 'SAINT MAURICE ES ALLIER'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63330', 'SAINT MAURICE PRES PIONSAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63460', 'SAINT MYON'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63710', 'SAINT NECTAIRE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63230', 'SAINT OURS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63440', 'SAINT PARDOUX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63610', 'SAINT PIERRE COLAMINE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63480', 'SAINT PIERRE LA BOURLHONNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63230', 'SAINT PIERRE LE CHASTEL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63210', 'SAINT PIERRE ROCHE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63310', 'SAINT PRIEST BRAMEFANT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63640', 'SAINT PRIEST DES CHAMPS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63490', 'SAINT QUENTIN SUR SAUXILLANGES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63440', 'SAINT QUINTIN SUR SIOULE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63440', 'SAINT REMY DE BLOT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'SAINT REMY DE CHARGNAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63550', 'SAINT REMY SUR DUROLLE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63660', 'SAINT ROMAIN'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63450', 'SAINT SANDOUX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63450', 'SAINT SATURNIN'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63950', 'SAINT SAUVES D''AUVERGNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63220', 'SAINT SAUVEUR LA SAGNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63760', 'SAINT SULPICE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63310', 'SAINT SYLVESTRE PRAGOULIN'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63790', 'SAINT VICTOR LA RIVIERE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63550', 'SAINT VICTOR MONTVIANEIX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'SAINT VINCENT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'SAINT YVOINE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63270', 'SALLEDES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63260', 'SARDON'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63970', 'SAULZET LE FROID'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63390', 'SAURET BESSERVE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'SAURIER'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63470', 'SAUVAGNAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'SAUVAGNAT SAINTE MARTHE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63840', 'SAUVESSANGES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63730', 'SAUVETAT (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63120', 'SAUVIAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63490', 'SAUXILLANGES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63750', 'SAVENNES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63530', 'SAYAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63120', 'SERMENTIZON'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63560', 'SERVANT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63190', 'SEYCHALLES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63690', 'SINGLES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'SOLIGNAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63490', 'SUGERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63720', 'SURAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63450', 'TALLENDE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63690', 'TAUVES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63460', 'TEILHEDE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63560', 'TEILHET'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'TERNANT LES EAUX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63300', 'THIERS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63600', 'THIOLIERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63260', 'THURET'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63470', 'TORTEBESSE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63680', 'TOUR D''AUVERGNE (LA)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63590', 'TOURS SUR MEYMONT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'TOURZEL RONZIERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63380', 'TRALAIGUES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63810', 'TREMOUILLE SAINT LOUP'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63520', 'TREZIOUX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63490', 'USSON'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63610', 'VALBELEIX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63600', 'VALCIVIERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63580', 'VALZ SOUS CHATEAUNEUF'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63720', 'VARENNES SUR MORGE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'VARENNES SUR USSON'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63910', 'VASSEL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63260', 'VENSAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63330', 'VERGHEAS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63580', 'VERNET LA VARENNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63710', 'VERNET SAINTE MARGUERITE (LE)'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63470', 'VERNEUGHEOL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63210', 'VERNINES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63320', 'VERRIERES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63910', 'VERTAIZON'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63480', 'VERTOLAYE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63960', 'VEYRE MONTON'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63270', 'VIC LE COMTE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'VICHEL'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63340', 'VILLENEUVE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63310', 'VILLENEUVE LES CERFS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63380', 'VILLOSANGES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63350', 'VINZELLES'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63330', 'VIRLET'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63250', 'VISCOMTAT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63410', 'VITRAC'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63840', 'VIVEROLS'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63500', 'VODABLE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63620', 'VOINGT'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63120', 'VOLLORE MONTAGNE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63120', 'VOLLORE VILLE'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63530', 'VOLVIC'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63700', 'YOUX'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63270', 'YRONDE ET BURON'),
('', '', '', 'Auvergne',    'Puy-de-Dôme (63) ', '63200', 'YSSAC LA TOURETTE'),
('', '0', '', 'Auvergne',   'Puy-de-Dôme (63)', '', 'AUTRE VILLE DU 63');